
UPDATE lux_FATTURA b SET B.NUM_FAT = 
(
select NUM_FAT from lux_NUMERA_FATTURA a

WHERE A.SOG_ID = B.SOG_ID
)
where      b.num_fat is null
and        b.az_id = '01'


